package epsi.mobile.constants;

//Contain Constants of Weather in SQL 
public class WeatherSQLConstants {
	
	// Name of base
	public static final String TABLE_NAME_WEATHER = "Weather";
	
	// Name of column
	public static final String COL_STOREID = "ID";
	public static final String COL_WEATHER = "Weather";
	public static final String COL_TEMPERATURE = "Temperature";
	public static final String COL_WINDSPEED = "WindSpeed";
	public static final String COL_ICON = "Icon";
	public static final String COL_LAST_UPDATE = "LastUpdate";
	
	// Number of column
	public static final int NUM_COL_STOREID = 0;
	public static final int NUM_COL_WEATHER = 1;
	public static final int NUM_COL_TEMPERATURE = 2;
	public static final int NUM_COL_WINDSPEED = 3;
	public static final int NUM_COL_ICON = 4;
	public static final int NUM_COL_LAST_UPDATE = 5;
	
	// Query to create the base of weather
	public static final String TABLE_CREATEREQUEST_WEATHER = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME_WEATHER + " ("
	+ COL_STOREID + " TEXT PRIMARY KEY, " 
    + COL_WEATHER + " TEXT, "
	+ COL_TEMPERATURE + " REAL, " 
	+ COL_WINDSPEED + " REAL, "
	+ COL_ICON + " TEXT, "
	+ COL_LAST_UPDATE + " TEXT "
    + ");";

}
